This report narrates the development of the the “trend summary” graphic that states the observed suicide rates in Florida county by sex, race, and ethnicity. Annotates ./analysis/trend-summary/trend-summary.R script.
Set the scene
Describe the working environment.
16.1 MB
[1] "list"
[1] "granularity_gls" "granularity_population"
| county |
chr |
0 |
0.0 |
67 |
NA |
NA |
NA |
| year |
chr |
0 |
0.0 |
17 |
NA |
NA |
NA |
| sex |
chr |
0 |
0.0 |
2 |
NA |
NA |
NA |
| race |
chr |
0 |
0.0 |
2 |
NA |
NA |
NA |
| ethnicity |
chr |
0 |
0.0 |
3 |
NA |
NA |
NA |
| age_group |
chr |
0 |
0.0 |
13 |
NA |
NA |
NA |
| population_count |
dou |
0 |
0.0 |
14511 |
0 |
2926.53 |
144791 |
| peer_group |
dou |
1612 |
1.5 |
25 |
1 |
32.85 |
81 |
| resident_deaths |
dou |
97718 |
90.5 |
40 |
1 |
3.30 |
41 |
| region |
chr |
101972 |
94.4 |
4 |
NA |
NA |
NA |
| community |
dou |
104156 |
96.4 |
35 |
8 |
491.19 |
3764 |
| professionals |
dou |
102388 |
94.8 |
45 |
4 |
95.89 |
1161 |
| county_gls |
log |
101972 |
94.4 |
2 |
1 |
1.00 |
1 |
| Orange |
8182 |
1605 |
| Saint Lucie |
1068 |
830 |
| Volusia |
2170 |
432 |
| Seminole |
2400 |
419 |
| Lake |
206 |
290 |
| Palm Beach |
935 |
241 |
| Saint Johns |
250 |
210 |
| Brevard |
1126 |
166 |
| Hernando |
115 |
131 |
| Marion |
325 |
119 |
| Indian River |
245 |
118 |
| Osceola |
35 |
84 |
| Sumter |
85 |
81 |
| Martin |
535 |
46 |
| Flagler |
397 |
29 |
| county |
chr |
0 |
0.0 |
67 |
NA |
NA |
NA |
| year |
chr |
0 |
0.0 |
17 |
NA |
NA |
NA |
| sex |
chr |
0 |
0.0 |
2 |
NA |
NA |
NA |
| age_group |
chr |
0 |
0.0 |
13 |
NA |
NA |
NA |
| race |
chr |
0 |
0.0 |
2 |
NA |
NA |
NA |
| ethnicity |
chr |
0 |
0.0 |
3 |
NA |
NA |
NA |
| racethnicity |
chr |
0 |
0.0 |
6 |
NA |
NA |
NA |
| region |
chr |
101972 |
94.4 |
4 |
NA |
NA |
NA |
| rgn |
chr |
101972 |
94.4 |
4 |
NA |
NA |
NA |
| population_count |
dou |
0 |
0.0 |
14511 |
0 |
2926.53 |
144791 |
| deaths_by_suicide |
dou |
97718 |
90.5 |
40 |
1 |
3.30 |
41 |
| community |
dou |
104156 |
96.4 |
35 |
8 |
491.19 |
3764 |
| professionals |
dou |
102388 |
94.8 |
45 |
4 |
95.89 |
1161 |
[1] "Brevard" "Orange" "Osceola" "Seminole" "Flagler" "Hernando" "Lake"
[8] "Marion" "Saint Johns" "Sumter" "Volusia" "Indian River" "Martin" "Palm Beach"
[15] "Saint Lucie"
I Exposition
II. Summary View
[1] “County FIPS code” “County Name, State” “Peer County Group”
Peer Group 1
|
county
|
county_gls
|
peer_group
|
|
Duval
|
TRUE
|
1
|
|
Hillsborough
|
NA
|
1
|
|
Miami-Dade
|
NA
|
1
|
|
Orange
|
TRUE
|
1
|
Peer Group 6
|
county
|
county_gls
|
peer_group
|
|
Clay
|
TRUE
|
6
|
|
Saint Johns
|
TRUE
|
6
|
|
Seminole
|
TRUE
|
6
|
Peer Group 7
|
county
|
county_gls
|
peer_group
|
|
Broward
|
NA
|
7
|
|
Palm Beach
|
TRUE
|
7
|
Peer Group 9
|
county
|
county_gls
|
peer_group
|
|
Osceola
|
TRUE
|
9
|
Peer Group 11
|
county
|
county_gls
|
peer_group
|
|
Hernando
|
TRUE
|
11
|
|
Lake
|
TRUE
|
11
|
|
Nassau
|
NA
|
11
|
|
Pasco
|
TRUE
|
11
|
Peer Group 24
|
county
|
county_gls
|
peer_group
|
|
Brevard
|
TRUE
|
24
|
|
Collier
|
NA
|
24
|
|
Escambia
|
NA
|
24
|
|
Flagler
|
TRUE
|
24
|
|
Lee
|
NA
|
24
|
|
Manatee
|
NA
|
24
|
|
Marion
|
TRUE
|
24
|
|
Martin
|
TRUE
|
24
|
|
Polk
|
TRUE
|
24
|
|
Saint Lucie
|
TRUE
|
24
|
|
Sarasota
|
NA
|
24
|
|
Volusia
|
TRUE
|
24
|
Peer Group 25
|
county
|
county_gls
|
peer_group
|
|
Charlotte
|
NA
|
25
|
|
Citrus
|
TRUE
|
25
|
|
Highlands
|
NA
|
25
|
|
Indian River
|
TRUE
|
25
|
|
Sumter
|
TRUE
|
25
|

III County View
Brevard

Orange

Osceola

Seminole

Flagler

Hernando

Lake

Marion

Saint Johns

Sumter

Volusia

Indian River

Martin

Palm Beach

Saint Lucie

Session Information
For the sake of documentation and reproducibility, the current report was rendered in the following environment. Click the line below to expand.
Environment
- Session info -------------------------------------------------------------------------------------------------------
setting value
version R version 3.5.2 (2018-12-20)
os Windows 10 x64
system x86_64, mingw32
ui RTerm
language (EN)
collate English_United States.1252
ctype English_United States.1252
tz America/Los_Angeles
date 2019-07-08
- Packages -----------------------------------------------------------------------------------------------------------
package * version date lib source
abind 1.4-5 2016-07-21 [1] CRAN (R 3.5.2)
assertthat 0.2.1 2019-03-21 [1] CRAN (R 3.5.3)
backports 1.1.4 2019-04-10 [1] CRAN (R 3.5.3)
callr 3.2.0 2019-03-15 [1] CRAN (R 3.5.3)
car 3.0-3 2019-05-27 [1] CRAN (R 3.5.3)
carData 3.0-2 2018-09-30 [1] CRAN (R 3.5.2)
cellranger 1.1.0 2016-07-27 [1] CRAN (R 3.5.3)
cli 1.1.0 2019-03-19 [1] CRAN (R 3.5.3)
codetools 0.2-16 2018-12-24 [1] CRAN (R 3.5.2)
colorspace 1.4-1 2019-03-18 [1] CRAN (R 3.5.3)
crayon 1.3.4 2017-09-16 [1] CRAN (R 3.5.3)
curl 3.3 2019-01-10 [1] CRAN (R 3.5.3)
data.table 1.12.2 2019-04-07 [1] CRAN (R 3.5.3)
desc 1.2.0 2018-05-01 [1] CRAN (R 3.5.3)
devtools 2.0.2 2019-04-08 [1] CRAN (R 3.5.3)
digest 0.6.19 2019-05-20 [1] CRAN (R 3.5.3)
dplyr * 0.8.1 2019-05-14 [1] CRAN (R 3.5.3)
DT 0.6 2019-05-09 [1] CRAN (R 3.5.3)
evaluate 0.14 2019-05-28 [1] CRAN (R 3.5.2)
explore 0.4.2 2019-05-22 [1] CRAN (R 3.5.3)
forcats 0.4.0 2019-02-17 [1] CRAN (R 3.5.3)
foreign 0.8-71 2018-07-20 [2] CRAN (R 3.5.2)
fs 1.3.1 2019-05-06 [1] CRAN (R 3.5.3)
ggplot2 * 3.1.1 2019-04-07 [1] CRAN (R 3.5.3)
ggpubr * 0.2 2018-11-15 [1] CRAN (R 3.5.3)
glue 1.3.1 2019-03-12 [1] CRAN (R 3.5.3)
gridExtra 2.3 2017-09-09 [1] CRAN (R 3.5.3)
gtable 0.3.0 2019-03-25 [1] CRAN (R 3.5.3)
haven 2.1.0 2019-02-19 [1] CRAN (R 3.5.3)
highr 0.8 2019-03-20 [1] CRAN (R 3.5.3)
hms 0.4.2 2018-03-10 [1] CRAN (R 3.5.3)
htmltools 0.3.6 2017-04-28 [1] CRAN (R 3.5.3)
htmlwidgets 1.3 2018-09-30 [1] CRAN (R 3.5.3)
httpuv 1.5.1 2019-04-05 [1] CRAN (R 3.5.3)
httr 1.4.0 2018-12-11 [1] CRAN (R 3.5.3)
kableExtra 1.1.0 2019-03-16 [1] CRAN (R 3.5.3)
knitr * 1.23 2019-05-18 [1] CRAN (R 3.5.2)
labeling 0.3 2014-08-23 [1] CRAN (R 3.5.2)
later 0.8.0 2019-02-11 [1] CRAN (R 3.5.3)
lazyeval 0.2.2 2019-03-15 [1] CRAN (R 3.5.3)
magrittr * 1.5 2014-11-22 [1] CRAN (R 3.5.3)
memoise 1.1.0 2017-04-21 [1] CRAN (R 3.5.3)
mime 0.6 2018-10-05 [1] CRAN (R 3.5.2)
munsell 0.5.0 2018-06-12 [1] CRAN (R 3.5.3)
openxlsx 4.1.0.1 2019-05-28 [1] CRAN (R 3.5.3)
pillar 1.4.1 2019-05-28 [1] CRAN (R 3.5.2)
pkgbuild 1.0.3 2019-03-20 [1] CRAN (R 3.5.3)
pkgconfig 2.0.2 2018-08-16 [1] CRAN (R 3.5.3)
pkgload 1.0.2 2018-10-29 [1] CRAN (R 3.5.3)
plyr 1.8.4 2016-06-08 [1] CRAN (R 3.5.3)
prettyunits 1.0.2 2015-07-13 [1] CRAN (R 3.5.3)
processx 3.3.1 2019-05-08 [1] CRAN (R 3.5.2)
promises 1.0.1 2018-04-13 [1] CRAN (R 3.5.3)
pryr 0.1.4 2018-02-18 [1] CRAN (R 3.5.3)
ps 1.3.0 2018-12-21 [1] CRAN (R 3.5.3)
purrr 0.3.2 2019-03-15 [1] CRAN (R 3.5.3)
R6 2.4.0 2019-02-14 [1] CRAN (R 3.5.3)
Rcpp 1.0.1 2019-03-17 [1] CRAN (R 3.5.3)
readr 1.3.1 2018-12-21 [1] CRAN (R 3.5.3)
readxl 1.3.1 2019-03-13 [1] CRAN (R 3.5.3)
remotes 2.0.4 2019-04-10 [1] CRAN (R 3.5.3)
reshape2 1.4.3 2017-12-11 [1] CRAN (R 3.5.3)
rio 0.5.16 2018-11-26 [1] CRAN (R 3.5.3)
rlang 0.3.4 2019-04-07 [1] CRAN (R 3.5.3)
rmarkdown 1.13 2019-05-22 [1] CRAN (R 3.5.3)
rprojroot 1.3-2 2018-01-03 [1] CRAN (R 3.5.3)
rstudioapi 0.10 2019-03-19 [1] CRAN (R 3.5.3)
rvest 0.3.4 2019-05-15 [1] CRAN (R 3.5.3)
scales 1.0.0 2018-08-09 [1] CRAN (R 3.5.3)
sessioninfo 1.1.1 2018-11-05 [1] CRAN (R 3.5.3)
shiny 1.3.2 2019-04-22 [1] CRAN (R 3.5.2)
stringi 1.4.3 2019-03-12 [1] CRAN (R 3.5.3)
stringr 1.4.0 2019-02-10 [1] CRAN (R 3.5.3)
tibble 2.1.3 2019-06-06 [1] CRAN (R 3.5.3)
tidyr 0.8.3 2019-03-01 [1] CRAN (R 3.5.3)
tidyselect 0.2.5 2018-10-11 [1] CRAN (R 3.5.3)
usethis 1.5.0 2019-04-07 [1] CRAN (R 3.5.3)
viridisLite 0.3.0 2018-02-01 [1] CRAN (R 3.5.3)
webshot 0.5.1 2018-09-28 [1] CRAN (R 3.5.3)
withr 2.1.2 2018-03-15 [1] CRAN (R 3.5.3)
xfun 0.7 2019-05-14 [1] CRAN (R 3.5.3)
xml2 1.2.0 2018-01-24 [1] CRAN (R 3.5.3)
xtable 1.8-4 2019-04-21 [1] CRAN (R 3.5.3)
yaml 2.2.0 2018-07-25 [1] CRAN (R 3.5.2)
zip 2.0.2 2019-05-13 [1] CRAN (R 3.5.3)
[1] C:/Users/an499583/Documents/R/win-library/3.5
[2] C:/Program Files/R/R-3.5.2/library
Report rendered by an499583 at 2019-07-08, 09:29 -0700 in 43 seconds.